3.15 根据蔬菜采购量统计采购金额
import pandas as pd
df=pd.read_excel(r "D:\Pyobject2023\object\测试\素材\测试素材.统计每天采购疏菜金额.xlsx" )
print (df)
s=pd.Series([ 1.5,8,0.8 ], index =[ "白菜","辣椒","萝卜" ])
df[ "采购金额" ]=(df.iloc[:, 1 :]*s).sum( axis = 1 )
print (df)
返回：
| 日期 | 白菜 | 辣椒 | 萝卜 | |
|---|---|---|---|---|
| 0 | 2024-02-12 | 4 | 2.0 | 12 |
| 1 | 2024-02-13 | 5 | 1.0 | 14 |
| 2 | 2024-02-14 | 3 | 0.5 | 8 |
| 3 | 2024-02-15 | 2 | 3.0 | 5 |
| 4 | 2024-02-16 | 6 | 2.0 | 4 |
| 日期 | 白菜 | 辣椒 | 萝卜 | 采购金额 | |
|---|---|---|---|---|---|
| 0 | 2024-02-12 | 4 | 2.0 | 12 | 31.6 |
| 1 | 2024-02-13 | 5 | 1.0 | 14 | 26.7 |
| 2 | 2024-02-14 | 3 | 0.5 | 8 | 14.9 |
| 3 | 2024-02-15 | 2 | 3.0 | 5 | 31.0 |
| 4 | 2024-02-16 | 6 | 2.0 | 4 | 28.2 |